﻿CREATE TABLE [hr].[Appointment] (
    [Id]                   INT            IDENTITY (1, 1) NOT NULL,
    [PatientId]            INT            NOT NULL,
    [DoctorId]             INT            NOT NULL,
    [HospitalPolyclinicId] INT            NOT NULL,
    [Date]                 DATETIME       NOT NULL,
    [State]                INT            NOT NULL,
    [Result]               NVARCHAR (512) NULL,
    [CancelBy]             INT            NULL,
    [CancelOn]             DATETIME       NULL,
    [CancelReason]         NVARCHAR (256) NULL
);



